Skills Audit
Constants, variables and data types | Start | Week 3 | Week 6 |
Data and information | 3 | 2 | 2 |
Constants | 3 | 2 | 2 |
Variables | 3 | 2 | 2 |
Data types | 3 | 2 | 2 |
Purpose of data types | 4 | 2 | 2 |
Structures | |||
How data types can be combined to make data structures | 4 | 3 | 3 |
How data structures can make coding a solution to a problem simpler | 4 | 3 | 3 |
Program flow control | |||
Sequencing | 4 | 3 | 3 |
Selection | 4 | 3 | 3 |
Iteration | 4 | 3 | 3 |
Procedures and functions | |||
What procedures and functions are when to use procedures and functions | 4 | 2 | 2 |
Writing your own procedures and functions | 4 | 2 | 2 |
Built-in functions | 4 | 2 | 2 |
Parameters | 4 | 2 | 2 |
Return values | 4 | 2 | 2 |
Scope of variables, constants, functions and procedures | |||
Understand scope and identify value of a variable at a given point in code. | 4 | 3 | 2 |
Error handling | |||
Different types of error that can occur | 4 | 3 | 3 |
How to test your code for errors | 4 | 3 | 3 |
How to detect errors from within code | 4 | 3 | 3 |
How to recover from errors within the code | 4 | 3 | 3 |
Handling external data | |||
Using text files to read/write data | 4 | 4 | 4 |
Using databases to read/write data | 4 | 4 | 4 |
Computer structure | |||
Systems | 4 | 2 | 2 |
Hardware | 3 | 1 | 1 |
CPU (Central Processing Unit) | 3 | 1 | 1 |
Memory | 3 | 1 | 1 |
Secondary storage | 4 | 1 | 1 |
Algorithms | |||
Be able to create algorithms to solve simple problems | 4 | 2 | 2 |
Data representation | |||
Know how to convert between binary, denary and hexadecimal. | 3 | 2 | 1 |
Software development life cycle | |||
Lifecycle models that can be used (eg cyclical, waterfall, spiral) | 4 | 4 | 4 |
Prototyping | |||
Have experience of using prototyping to create solutions. | 4 | 3 | 3 |
Application testing | |||
Test simple code designs/algorithms using trace tables. | 4 | 2 | 2 |
Networking | |||
Client server | 4 | 4 | 2 |
Web application concepts | 4 | 4 | 3 |
Use of external code sources | |||
Explain the advantages and disadvantages of using such sources. | 4 | 4 | 4 |
Database concepts | |||
Query methods (SQL) | 4 | 4 | 2 |
Connecting to databases from applications and web based apps | 4 | 4 | 4 |
The use of computer technology in society | |||
Evaluate the impact of the use of computer technology in society. | 4 | 4 | 4 |